SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_SearchTestPlatform]
    (
      @JOL_Test_Title VARCHAR(100)
    )
AS 
    SELECT  JOL_Test_No,
            JOL_Test_Title,
            JOL_Test_Type,
            JOL_Test_Website,
            JOL_Test_ImageUrl
    FROM    dbo.JOL_TestPlatform
    WHERE   JOL_Test_Title LIKE '%' + @JOL_Test_Title + '%'
    ORDER BY JOL_Test_AddTime DESC,
            JOL_Test_UpdateTime DESC
GO
